<?php

/**
 * accueil actions.
 *
 * @package    Colibri
 * @subpackage Page de demarrage
 * @author     Your name here
 * @version    SVN: $Id: actions.class.php 12474 2008-10-31 10:41:27Z fabien $
 */
class homeActions extends sfActions{
  public function executeIndex(sfWebRequest $request){
  		$q = Doctrine_Query::create()->from('message m')->where('m.public = true')
  			->addWhere('m.etat = 2')
  			->addWhere('datedebut <= ?', date('Y-m-d'))
  			->addWhere('datefin >= ?', date('Y-m-d'));
		$q->setHydrationMode(Doctrine::HYDRATE_ARRAY);  			
  		$this->messages = $q->execute();  	
  }
  

  
}